package net.wantongtech.xa.uploadbasicinfo.dao;

import com.wtkj.dao.impl.BaseDataTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author MaShibo
 * 2021/3/12 0012
 */
@Repository
public class GeneratePortalTransOutViewScriptDao extends BaseDataTemplate {


    public List<String> queryAllPortalTransOutTableNames() {
        final String sql =
                "SELECT a.table_name\n" +
                        "  FROM dba_tables a\n" +
                        " WHERE a.table_name LIKE 'TR_PORTAL_TRANSOUT_%'\n" +
                        " ORDER BY a.table_name";
        return jdbcTemplate.queryForList(sql, String.class);
    }


}
